package com.lswms.modules.lswms.excel.recipient;

import cn.afterturn.easypoi.excel.annotation.Excel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.math.BigDecimal;
import java.util.Date;

/**
 * ${comments}
 *
 * @author DX sunlightcs@gmail.com
 * @since 1.0.0 2021-07-19
 */
@Data
public class RecipientsExcel {
    @Excel(name="领用号")
	private Integer recipientkey;
    @Excel(name = "领用人卡号")
    private String cardid;
    @Excel(name = "领用人ID")
    private String recipientid;
    @Excel(name = "领用人")
    private String recipient;
    @Excel(name = "类型")
    private String recipienttypestr;
    @Excel(name = "状态")
    private String statusstr;
    @Excel(name = "物料编码")
    private String sku;
    @Excel(name = "物料名称")
    private String descr;
    @Excel(name = "计量编码/工装号")
    private String factorycdoe;
    @Excel(name = "预期数量")
    private BigDecimal preqty;
    @Excel(name = "数量")
    private BigDecimal qty;
    @Excel(name = "部门")
    private String lot7;
    @Excel(name = "领用时间",exportFormat="yyyy-MM-dd HH:mm:ss")
    private Date recipienttime;
    @Excel(name = "发布人")
    private String issuer;
    @Excel(name = "归还数量")
    private BigDecimal backqty;
    @Excel(name = "批号")
    private String lot;
    @Excel(name = "自库位")
    private String fromloc;
    @Excel(name = "自箱")
    private String fromtray;
    @Excel(name = "自格")
    private String frombox;
    @Excel(name = "当前库位")
    private String loc;
    @Excel(name = "当前箱")
    private String tray;
    @Excel(name = "当前格")
    private String box;
    @Excel(name = "至库位")
    private String toloc;
    @Excel(name = "至箱")
    private String totray;
    @Excel(name = "至格")
    private String tobox;
    @Excel(name = "备用字段1")
    private String reserve1;
    @Excel(name = "备用字段2")
    private String reserve2;
    @Excel(name = "备用字段3")
    private String reserve3;
    @Excel(name = "备用字段4")
    private String reserve4;
    @Excel(name = "备用字段5")
    private String reserve5;
    @Excel(name = "创建人")
    private String adduser;
    @Excel(name = "创建时间" ,exportFormat="yyyy-MM-dd HH:mm:ss")
    private Date addtime;
    @Excel(name = "更新人")
    private String updatuser;
    @Excel(name = "更新时间" ,exportFormat="yyyy-MM-dd HH:mm:ss")
    private Date updatetime;

}